![[Jenkins]](/kapua/static/922b6dea/images/svgs/logo.svg){kind=logo}
Failed
Trigger service tests.Adding "Device Connect" Schedule With Non-Unique End Date Parameter (from org.eclipse.kapua.integration.service.jobScheduling.RunTriggerServiceI9nTest)
Error Message
An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
Stacktrace
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:99) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:499) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:220) at org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(UserServiceSteps.java:586) at ✽.I login as user with name "kapua-sys" and password "kapua-password"(classpath:features/jobScheduling/TriggerServiceI9n.feature:180) Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Unexpected error while looking for the user! at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:87) at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:275) at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:275) at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:260) at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:203) at org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(UserServiceSteps.java:586) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at io.cucumber.java.Invoker.doInvoke(Invoker.java:66) at io.cucumber.java.Invoker.invoke(Invoker.java:24) at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47) at io.cucumber.java.JavaStepDefinition.execute(JavaStepDefinition.java:29) at io.cucumber.core.runner.CoreStepDefinition.execute(CoreStepDefinition.java:66) at io.cucumber.core.runner.PickleStepDefinitionMatch.runStep(PickleStepDefinitionMatch.java:63) at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10) at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92) at io.cucumber.core.runner.TestStep.run(TestStep.java:64) at io.cucumber.core.runner.PickleStepTestStep.run(PickleStepTestStep.java:51) at io.cucumber.core.runner.TestCase.run(TestCase.java:104) at io.cucumber.core.runner.Runner.runPickle(Runner.java:73) at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151) at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135) at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200) at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169) at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581) Caused by: org.apache.shiro.ShiroException: Unexpected error while looking for the user! at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:80) at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:571) at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:61) ... 51 more Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation. at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:84) at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:107) at org.eclipse.kapua.commons.jpa.JpaTxContext.convertPersistenceException(JpaTxContext.java:78) at org.eclipse.kapua.storage.TxManagerImpl.execute(TxManagerImpl.java:61) at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:288) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:76) at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:116) at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:76) ... 53 more Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200] Error Code: 42102 Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)") at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482) at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindAllByField(KapuaEntityJpaRepository.java:650) at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindByField(KapuaEntityJpaRepository.java:607) at org.eclipse.kapua.commons.jpa.KapuaNamedEntityJpaRepository.findByName(KapuaNamedEntityJpaRepository.java:52) at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByNameCached(KapuaNamedEntityRepositoryCachingWrapper.java:63) at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByName(KapuaNamedEntityRepositoryCachingWrapper.java:50) at org.eclipse.kapua.service.user.internal.UserServiceImpl.lambda$findByName$11(UserServiceImpl.java:288) at org.eclipse.kapua.storage.TxManagerImpl.execute(TxManagerImpl.java:50) ... 57 more Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200] Error Code: 42102 Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:345) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:765) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2776) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2729) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262) ... 65 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) at org.h2.message.DbException.get(DbException.java:205) at org.h2.message.DbException.get(DbException.java:181) at org.h2.command.Parser.readTableOrView(Parser.java:7628) at org.h2.command.Parser.readTableFilter(Parser.java:1970) at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827) at org.h2.command.Parser.parseSelect(Parser.java:2959) at org.h2.command.Parser.parseQuerySub(Parser.java:2817) at org.h2.command.Parser.parseSelectUnion(Parser.java:2649) at org.h2.command.Parser.parseQuery(Parser.java:2620) at org.h2.command.Parser.parsePrepared(Parser.java:868) at org.h2.command.Parser.parse(Parser.java:843) at org.h2.command.Parser.parse(Parser.java:815) at org.h2.command.Parser.prepareCommand(Parser.java:738) at org.h2.engine.Session.prepareLocal(Session.java:657) at org.h2.engine.Session.prepareCommand(Session.java:595) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1611) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1558) at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:762) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628) ... 86 more
Standard Output
@jobsIntegrationBase @env_docker_base
Scenario: Adding "Device Connect" Schedule With Non-Unique End Date Parameter # features/jobScheduling/TriggerServiceI9n.feature:174
18:22:00.868 [main] WARN eclipselink.logging.all - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
Error Code: 42102
Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)")
18:22:00.869 [main] ERROR o.e.kapua.storage.TxManagerImpl - Non-recoverable exception, failing
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
Error Code: 42102
Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)")
at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)
at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482)
at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindAllByField(KapuaEntityJpaRepository.java:650)
at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindByField(KapuaEntityJpaRepository.java:607)
at org.eclipse.kapua.commons.jpa.KapuaNamedEntityJpaRepository.findByName(KapuaNamedEntityJpaRepository.java:52)
at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByNameCached(KapuaNamedEntityRepositoryCachingWrapper.java:63)
at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByName(KapuaNamedEntityRepositoryCachingWrapper.java:50)
at org.eclipse.kapua.service.user.internal.UserServiceImpl.lambda$findByName$11(UserServiceImpl.java:288)
at org.eclipse.kapua.storage.TxManagerImpl.execute(TxManagerImpl.java:50)
at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:288)
at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:76)
at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:116)
at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:76)
at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:571)
at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:61)
at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:275)
at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:275)
at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:260)
at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:203)
at org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(UserServiceSteps.java:586)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at io.cucumber.java.Invoker.doInvoke(Invoker.java:66)
at io.cucumber.java.Invoker.invoke(Invoker.java:24)
at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47)
at io.cucumber.java.JavaStepDefinition.execute(JavaStepDefinition.java:29)
at io.cucumber.core.runner.CoreStepDefinition.execute(CoreStepDefinition.java:66)
at io.cucumber.core.runner.PickleStepDefinitionMatch.runStep(PickleStepDefinitionMatch.java:63)
at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10)
at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92)
at io.cucumber.core.runner.TestStep.run(TestStep.java:64)
at io.cucumber.core.runner.PickleStepTestStep.run(PickleStepTestStep.java:51)
at io.cucumber.core.runner.TestCase.run(TestCase.java:104)
at io.cucumber.core.runner.Runner.runPickle(Runner.java:73)
at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
Caused by: org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
Error Code: 42102
Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:345)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:765)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2776)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2729)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
... 65 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableFilter(Parser.java:1970)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827)
at org.h2.command.Parser.parseSelect(Parser.java:2959)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1611)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1558)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:762)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628)
... 86 common frames omitted
An unexpected exception was raised: KapuaException with message: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
Given I login as user with name "kapua-sys" and password "kapua-password" # org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(java.lang.String,java.lang.String)
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:99)
at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:499)
at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:220)
at org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(UserServiceSteps.java:586)
at ✽.I login as user with name "kapua-sys" and password "kapua-password"(classpath:features/jobScheduling/TriggerServiceI9n.feature:180)
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Unexpected error while looking for the user!
at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:87)
at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:275)
at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:275)
at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:260)
at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:203)
at org.eclipse.kapua.service.user.steps.UserServiceSteps.loginUser(UserServiceSteps.java:586)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at io.cucumber.java.Invoker.doInvoke(Invoker.java:66)
at io.cucumber.java.Invoker.invoke(Invoker.java:24)
at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47)
at io.cucumber.java.JavaStepDefinition.execute(JavaStepDefinition.java:29)
at io.cucumber.core.runner.CoreStepDefinition.execute(CoreStepDefinition.java:66)
at io.cucumber.core.runner.PickleStepDefinitionMatch.runStep(PickleStepDefinitionMatch.java:63)
at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10)
at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92)
at io.cucumber.core.runner.TestStep.run(TestStep.java:64)
at io.cucumber.core.runner.PickleStepTestStep.run(PickleStepTestStep.java:51)
at io.cucumber.core.runner.TestCase.run(TestCase.java:104)
at io.cucumber.core.runner.Runner.runPickle(Runner.java:73)
at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
Caused by: org.apache.shiro.ShiroException: Unexpected error while looking for the user!
at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:80)
at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:571)
at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:61)
... 51 more
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:84)
at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:107)
at org.eclipse.kapua.commons.jpa.JpaTxContext.convertPersistenceException(JpaTxContext.java:78)
at org.eclipse.kapua.storage.TxManagerImpl.execute(TxManagerImpl.java:61)
at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:288)
at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:76)
at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:116)
at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:76)
... 53 more
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
Error Code: 42102
Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)")
at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)
at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482)
at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindAllByField(KapuaEntityJpaRepository.java:650)
at org.eclipse.kapua.commons.jpa.KapuaEntityJpaRepository.doFindByField(KapuaEntityJpaRepository.java:607)
at org.eclipse.kapua.commons.jpa.KapuaNamedEntityJpaRepository.findByName(KapuaNamedEntityJpaRepository.java:52)
at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByNameCached(KapuaNamedEntityRepositoryCachingWrapper.java:63)
at org.eclipse.kapua.commons.storage.KapuaNamedEntityRepositoryCachingWrapper.findByName(KapuaNamedEntityRepositoryCachingWrapper.java:50)
at org.eclipse.kapua.service.user.internal.UserServiceImpl.lambda$findByName$11(UserServiceImpl.java:288)
at org.eclipse.kapua.storage.TxManagerImpl.execute(TxManagerImpl.java:50)
... 57 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
Error Code: 42102
Call: SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=UserImpl sql="SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?)")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:345)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:765)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2776)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2729)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
... 65 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USR_USER" not found; SQL statement:
SELECT attributes, created_on, description, display_name, email, expiration_date, external_id, external_username, modified_on, name, optlock, phone_number, properties, status, user_type, created_by, id, modified_by, scope_id FROM usr_user WHERE (name = ?) [42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableFilter(Parser.java:1970)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827)
at org.h2.command.Parser.parseSelect(Parser.java:2959)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1611)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1558)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:762)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628)
... 86 more
And I create a job with the name "job0" # org.eclipse.kapua.service.job.steps.JobServiceSteps.createANamedJob(java.lang.String)
When I find scheduler properties with name "Device Connect" # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.iFindTriggerPropertiesWithName(java.lang.String)
Then A regular trigger creator with the name "schedule0" is created # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.aRegularTriggerCreatorWithTheName(java.lang.String)
And The trigger is set to start on "12-01-2030" at "10:10" # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.setTriggerStartDate(java.lang.String,java.lang.String)
And The trigger is set to end on "15-12-2030" at "10:10" # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.setTriggerEndDate(java.lang.String,java.lang.String)
Then I create a new trigger from the existing creator with previously defined date properties # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.createTriggerWithDateProperties()
And A regular trigger creator with the name "schedule1" is created # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.aRegularTriggerCreatorWithTheName(java.lang.String)
And The trigger is set to start on "12-12-2030" at "10:10" # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.setTriggerStartDate(java.lang.String,java.lang.String)
And The trigger is set to end on "15-12-2030" at "10:10" # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.setTriggerEndDate(java.lang.String,java.lang.String)
And I create a new trigger from the existing creator with previously defined date properties # org.eclipse.kapua.service.scheduler.steps.JobScheduleServiceSteps.createTriggerWithDateProperties()
And I logout # org.eclipse.kapua.service.user.steps.UserServiceSteps.logout()
18:22:00.875 [main] INFO o.eclipse.kapua.qa.common.BasicSteps - Database cleanup...
18:22:00.876 [main] INFO o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - Running database script from resources...
18:22:00.876 [main] INFO o.e.k.c.jpa.SimpleSqlScriptExecutor - Running resources script: sql/all_delete.sql
18:22:00.877 [main] WARN eclipselink.logging.all - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
[42102-200]
Error Code: 42102
Call: /*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
Query: DataModifyQuery(sql="/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
")
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
[42102-200]
Error Code: 42102
Call: /*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
Query: DataModifyQuery(sql="/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
")
at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:312)
at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106)
at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52)
at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102)
at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:443)
at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:414)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
[42102-200]
Error Code: 42102
Call: /*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
Query: DataModifyQuery(sql="/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:313)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:317)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:288)
at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:87)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:302)
at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106)
at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52)
at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102)
at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:443)
at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:414)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at io.cucumber.java.Invoker.doInvoke(Invoker.java:66)
at io.cucumber.java.Invoker.invoke(Invoker.java:24)
at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47)
at io.cucumber.java.JavaHookDefinition.execute(JavaHookDefinition.java:59)
at io.cucumber.core.runner.CoreHookDefinition.execute(CoreHookDefinition.java:46)
at io.cucumber.core.runner.HookDefinitionMatch.runStep(HookDefinitionMatch.java:21)
at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10)
at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92)
at io.cucumber.core.runner.TestStep.run(TestStep.java:64)
at io.cucumber.core.runner.TestCase.run(TestCase.java:110)
at io.cucumber.core.runner.Runner.runPickle(Runner.java:73)
at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135)
at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200)
at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
/*******************************************************************************
* Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
*
* Contributors:
* Eurotech - initial API and implementation
*******************************************************************************/
UPDATE act_account SET scope_id = null;
DELETE
FROM act_account
WHERE id NOT IN (1);
DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
DELETE
FROM atht_access_token;
DELETE
FROM atht_mfa_option;
DELETE
FROM atht_scratch_code;
DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);
DELETE
FROM dvc_device_connection;
DELETE
FROM dvc_device;
DELETE
FROM dvc_device_event;
DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));
DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);
DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);
DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));
DELETE
FROM athz_group;
DELETE
FROM tag_tag;
DELETE
FROM job_job;
DELETE
FROM job_job_execution;
DELETE
FROM job_job_step;
DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
DELETE
FROM job_job_step_properties;
DELETE
FROM job_job_target;
DELETE
FROM schdl_trigger;
DELETE
FROM schdl_trigger_properties;
[42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableOrView(Parser.java:7599)
at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1350)
at org.h2.command.Parser.parseUpdate(Parser.java:1288)
at org.h2.command.Parser.parsePrepared(Parser.java:1005)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1611)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1558)
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:762)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628)
... 63 more